USE Contacts
GO
--INSERT FOR Personality
EXEC SP_InsPersonality 100,'Ivanov','Alexander','Petrovich','m','8(928)211-00-03','8(7922)4-13-81','Alex@mail.ru','D:\Photo\1.JPG','',200,304

EXEC SP_InsPersonality 101,'Sidorov','Petr','Sergeevich','m','8(903)413-80-10','8(7922)4-12-80','Petr@rambler.ru','D:\Photo\2.JPG','',201,305

EXEC SP_InsPersonality 102,'Shpak','Elena','Sergeevna','w','8(918)314-15-20','8(495)1-99-92','Shpak@mail.ru','D:\Photo\3.JPG','',202,303

EXEC SP_InsPersonality 103,'Nyrlieva','Lyubov','Vasilievna','w','8(928)625-16-27','8(793)2-16-11','Nyrlieva@mail.ru','D:\Photo\4.JPG','',203,300

EXEC SP_InsPersonality 104,'Dzhabiev','Konstantin','Alexandrovich','m','8(918)818-28-18','8(7922)5-51-16','Dzhabiev@gmail.com','D:\Photo\5.JPG','',206,307

EXEC SP_InsPersonality 105,'Galieva','Tatyana','Ivanovna','w','8(928)318-18-01','8(793)5-23-17','Galieva@mail.ru','D:\Photo\6.JPG','',204,306

EXEC SP_InsPersonality 106,'Kovaleva','Svetlana','Petrovna','w','8(928)356-14-15','8(7932)6-12-15','Kovaleva@mail.ru','D:\Photo\7.JPG','',205,301

EXEC SP_InsPersonality 107,'Dzhangaliev','Pavel','Andreevich','m','8(918)211-40-20','8(793)2-13-11','Pavel@gmail.com','D:\Photo\8.JPG','',207,308

EXEC SP_InsPersonality 108,'Sipko','Roman','Romanovich','m','8(928)415-63-03','8(495)1-31-18','Sipko@mail.ru','D:\Photo\9.JPG','',208,311

EXEC SP_InsPersonality 109,'Laskov','Sergey','Vladimirovich','m','8(928)652-31-53','8(7922)5-41-25','Sergey@rambler.ru','D:\Photo\10.JPG','',209,310

EXEC SP_InsPersonality 110,'Svetlakova','Irina','Viktorovna','w','8(918)325-64-95','8(7922)5-36-81','Irina@mail.ru','D:\Photo\11.JPG','',210,302

EXEC SP_InsPersonality 111,'Belekov','Alexander','Romanovich','m','8(903)492-43-78','8(7937)2-45-36','Alexander@gmail.com','D:\Photo\12.JPG','',211,309

EXEC SP_InsPersonality 112,'Sichev','Ilya','Konstantinovich','m','8(918)632-61-06','8(7937)4-63-16','Sichev@rambler.ru','D:\Photo\13.JPG','',212,312

EXEC SP_InsPersonality 113,'Kropotkina','Julia','Valerievna','w','8(903)416-32-20','8(793)5-31-88','Julia@mail.ru','D:\Photo\14.JPG','',213,306

EXEC SP_InsPersonality 114,'Kalayan','Edgar','Badrosovich','m','8(918)244-12-65','8(7922)4-54-81','Edgar@mail.ru','D:\Photo\15.JPG','',214,313

EXEC SP_InsPersonality 115,'Koshkin','Anton','Vladimirovich','m','8(928)366-14-62','8(495)1-18-66','Koshkin@mail.ru','D:\Photo\16.JPG','',215,313

EXEC SP_InsPersonality 116,'Ivanov','Alexey','Petrovich','m','8(928)211-00-04','8(812)3-21-80','Alexey@mail.ru','D:\Photo\17.JPG','',216,304

EXEC SP_InsPersonality 117,'Siniy','Dmitriy','Alexeevich','m','8(928)456-95-46','8(793)5-74-63','Siniy@gmail.com','D:\Photo\18.JPG','',217,308

EXEC SP_InsPersonality 118,'Inyanov','Artem','Petrovich','m','8(988)635-48-68','8(793)5-73-16','Inyanov@rambler.ru','D:\Photo\19.JPG','',218,307

--INSERT FOR PlaceResidence
EXEC SP_InsPlaceResidence 200,'Minvody','Pyshkina','23',''

EXEC SP_InsPlaceResidence 201,'Minvody','Lomovaya','58',''

EXEC SP_InsPlaceResidence 202,'Moscow','Sydakova','402/A','23'

EXEC SP_InsPlaceResidence 203,'Pyatigorsk','Vlasova','34','5'

EXEC SP_InsPlaceResidence 204,'Pyatigorsk','Bytirina','40',''

EXEC SP_InsPlaceResidence 205,'Zeleznovodsk','Lenina','21',''

EXEC SP_InsPlaceResidence 206,'Minvody','Stavropolskaya','34','21'

EXEC SP_InsPlaceResidence 207,'Pyatigorsk','Anisimova','128/B',''

EXEC SP_InsPlaceResidence 208,'Moscow','Sydakova','402/A','41'

EXEC SP_InsPlaceResidence 209,'Minvody','Zeleznovodskaya','91',''

EXEC SP_InsPlaceResidence 210,'Essentyki','Sovetskaya','90',''

EXEC SP_InsPlaceResidence 211,'Kislovodsk','Veselaya','102','52'

EXEC SP_InsPlaceResidence 212,'Kislovodsk','Aviachii','5',''

EXEC SP_InsPlaceResidence 213,'Pyatigorsk','Anisimova','63',''

EXEC SP_InsPlaceResidence 214,'Minvody','Lomovaya','105',''

EXEC SP_InsPlaceResidence 215,'Moscow','Zarechie','418/B','39'

EXEC SP_InsPlaceResidence 216,'S.Peterbyrg','Kazanskaya','200',''

EXEC SP_InsPlaceResidence 217,'Pyatigorsk','Baksanskaya','23','6'

EXEC SP_InsPlaceResidence 218,'Pyatigorsk','Baksanskaya','23','15'

--INSERT FOR Position
EXEC SP_InsPosition 300,'Glavniyi byxgalter',400

EXEC SP_InsPosition 301,'byxgalter',400

EXEC SP_InsPosition 302,'cassir',400

EXEC SP_InsPosition 303,'Nachalnik otdela kadrov',401

EXEC SP_InsPosition 304,'Programmist',402

EXEC SP_InsPosition 305,'Inzhener-programmist',402

EXEC SP_InsPosition 306,'Razrabotchik',402

EXEC SP_InsPosition 307,'Naladchik',403

EXEC SP_InsPosition 308,'System administrator',403

EXEC SP_InsPosition 309,'Arhitektor',404

EXEC SP_InsPosition 310,'Nachalnik otdela proektirovaniya',404

EXEC SP_InsPosition 311,'Nachalnik otdela testirovaniya',405

EXEC SP_InsPosition 312,'Inzhener-tester',405

EXEC SP_InsPosition 313,'tester',405

--INSERT FOR Subdivision
EXEC SP_InsSubdivision 400,'Buxgalteriya'

EXEC SP_InsSubdivision 401,'Otdel kadrov'

EXEC SP_InsSubdivision 402,'Otdel razrabotki'

EXEC SP_InsSubdivision 403,'Otdel naladchikov'

EXEC SP_InsSubdivision 404,'Otdel proektirovaniya'

EXEC SP_InsSubdivision 405,'Otdel testirovaniya'



